-- MedAssist Clinic Management System
-- Triggers from supplied database
USE `medassets`;

DELIMITER $$

CREATE TRIGGER `trg_patient_after_delete`
AFTER DELETE ON `patient`
FOR EACH ROW
BEGIN
INSERT INTO auditlog
(TableName, RecordID, ActionType, ActionDescription)
VALUES
(
'patient',
OLD.PatientID,
'DELETE',
CONCAT('Patient deleted: ', OLD.FirstName, ' ', OLD.LastName)
);
END$$

CREATE TRIGGER `trg_patient_after_insert`
AFTER INSERT ON `patient`
FOR EACH ROW
BEGIN
INSERT INTO auditlog
(TableName, RecordID, ActionType, ActionDescription)
VALUES
(
'patient',
NEW.PatientID,
'INSERT',
CONCAT('New patient added: ', NEW.FirstName, ' ', NEW.LastName)
);
END$$

CREATE TRIGGER `trg_patient_after_update`
AFTER UPDATE ON `patient`
FOR EACH ROW
BEGIN
INSERT INTO auditlog
(TableName, RecordID, ActionType, ActionDescription)
VALUES
(
'patient',
NEW.PatientID,
'UPDATE',
CONCAT('Patient updated: ', NEW.FirstName, ' ', NEW.LastName)
);
END$$

DELIMITER ;
